Data Prepatation

datasource: https://www.kaggle.com/datasets/imdevskp/corona-virus-report

Out of all these data sets we use worldmeter_data as this consists of all the data that is required and new parameters can be derived

Trend of the data cases

we will try to answer the top 10 countries with maximum Total cases

Total Covid cases

Total Deaths

Total Active Cases

Total cases/1M population

Even though the total number of cases in USA is very high, Qatar has more number of total covid cases when normalize the cases one total population

Deaths/1M pop

Even tough we have more number of covid cases in countries like USA, Brazil, India. Recovery was good, covid spread/Milliion is less and less number of deaths/Million are recorded

We can also represent the data with treemap

We can visualize the percentage of cases across all the countries with the above tree map

Top 10 countries with Total Confirmed Cases, Total Recovered Cases, Total Deaths,Total Active Cases

At one Glance data visualization is possbile with stacked bar graphs

Finding the percentage of tests covered for each country

We can get the percentage by total tests / population

Luxembourg is the country where almost everyone went through covid 19 test

Now we plot the grapth for percentage of total tests conducted

if percentage of total tests are very less there should be chance that more number of total cases, active cases in a conutry

Understanding the data with ratios

Critical/Serious covid case to deaths

In most instances critical cases are converted into deaths for the countries Namibia, Turk, uzbekisthan compared to others`

Deaths to recovered ratio

More than 50% of chance that the perople from Yemen Belgium can dead when compared with the recovered cases

Tests to confirmed ratio

We can get data for each country as follows

If we need the data for each date, we can get it as follows